package rkdwogus7.exam;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class JDBCCDInfo implements CDInfoService {
	
	private static final String DRV = "oracle.jdbc.OracleDriver";
	private static final String URL = "jdbc:oracle:thin:@//localhost:1521/xe";
	private static final String USR = "scott";
	private static final String PWD = "TIGER";
	
	private static final String insertSQL = "insert into sungjuk" + "(sjno, name, kor, eng, mat)"
			 + "VALUES (SJNO.nextval, ?, ?, ?, ?) ";
		private static final String selectSQL = " select * from sungjuk order by sjno desc";
		private static final String updateSQL = " update sungjuk set name = , kor = , eng = , mat =  ";
		private static final String deleteSQL = " delete from sungjuk where sjno = ? ";
		
		@Override
		public boolean newCDInfo(CDInfoVO cd) {
			Connection conn = null;
			
			return false;
		}
		@Override
		public String readCDInfo() {
			return null;
		}
		@Override
		public boolean modifyCDInfo(CDInfoVO cd) {
			return false;
		}
		@Override
		public boolean removeCDInfo(String key) {
			return false;
		}
		
		

	

}
